package com.lovo.sgproj.dao;

import com.lovo.sgproj.bean.RecordBean;

import java.util.ArrayList;

public interface RecordDAO {
    //select * from t_record where fk_roomid = ?
    public ArrayList<RecordBean> findAllRecordByRoomID(int roomID);

    //1、insert into t_record (f_description,f_reportDate,f_solutionResult,fk_roomId) values(?,?,true,?);
    //2、update t_room set f_roomStatus = 0 where pk_roomid = ?
    public void insertRecord(RecordBean record, int roomID);

    //1、update t_record set f_solution = true where pk_recordId = ?
    //2、select count(*) from t_record where f_solution=false and fk_roomid = ?
    //3、update t_room set f_roomStatus = 1 where pk_roomID = ?
    public void updateRecord(int recordID, int roomID);
}
